<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page import="java.sql.*" %>
<%@page import="DAO.DBCon"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>	企业岗位基本信息</title>
</head>
<style>
p.top
{
	background-color:#e6e4e4;
	border:3px solid red;
	border-radius:10px;
	margin-top:0px;
	margin-bottom:0px;
	margin-color:#e6e4e4;
}
.font{
	font-family: SimSun;
	font-weight: bold;
	font-size: 25px;
}
.button1{
	position:absolute;
	top:800px;
	left:830px;
	width: 100px;
	height: 40px;
	background-color:yellow;
	border-radius: 10px;
	font-family: SimSun;
	font-size: 15px;
	font-weight:bold;	
}
.button2{
	position:absolute;
	top:800px;
	left:1030px;
	width: 100px;
	height: 40px;
	background-color:yellow;
	border-radius: 10px;
	font-family: SimSun;
	font-size: 15px;
	font-weight:bold;	
}
body{
	background-color:#e6e4e4;
}
</style>
<body>
	<p class="top" align="center"><font size="40px" weight="bold">企业岗位信息查看及修改</font></p>
		<p align="center">
			<table border="1">
				<tr><th>部门名称</th><th>岗位名称</th>
<!-- 这里采用rs.next进行循环 ............................................     -->
	<% 
		DBCon dbCon = new DBCon();
		Connection connection = dbCon.getConnection();
		String sql = "select * from ejpt91 where Dname=\""+request.getParameter("Dname1")+"\"" ;
		try{
			PreparedStatement stmt = connection.prepareStatement(sql);
			ResultSet rs1 = stmt.executeQuery();
			int i = 1;
			while(rs1.next()){
				out.print("<tr>");
				out.print("<td>"+rs1.getString("Dname")+"</td>");
				out.print("<td>"+rs1.getString("Pname")+"</td>");
				out.print("<td>");
				out.print("<input type=\"button\" onclick=\"window.location.href='EJPChange?Pname1="+rs1.getString("Pname")+"'\" value=\"删除岗位\" ></td></tr>");		
				i++;
					}
			}catch(Exception e){
			}
	%>
			<tr><td><%=request.getParameter("Dname1") %></td>
			<form action="EJPChangeIn" method="post">
			<td><input type="text" name="insert1"></td><td><input type="hidden" name="hidden" value="<%=request.getParameter("Dname1") %>"><input type="submit" value="添加岗位" ></td>
			</form></tr>
			</table>
		</p>	
	<p align="center">
		<input type="button"  onclick="window.location.href='EBISearch.jsp'" class="button1" value="查询">
		<input type="button"  onclick="window.location.href='EDIChange.jsp'" class="button2" value="返回">
	</p>
</body>
</html>